﻿CREATE TABLE [dbo].[tCountry]
    (
      [CountryID] [int] IDENTITY(1, 1)
                        NOT NULL
                        CONSTRAINT [PK_tCountry] PRIMARY KEY ,
      [CountryGUID] [uniqueidentifier] NOT NULL ,
      [Name] [nvarchar](200) NOT NULL ,
      [TwoLetterISOCode] [nvarchar](2) NULL ,
      [ThreeLetterISOCode] [nvarchar](3) NULL ,
      [NumericISOCode] [nvarchar](3) NULL ,
      [Published] [tinyint] NOT NULL ,
      [DisplayOrder] [int] NOT NULL ,
      [ExtensionData] [ntext] NULL ,
      [CreatedOn_utc] [datetime2] NOT NULL CONSTRAINT [df_tCountry_CreatedOn_utc] DEFAULT GETUTCDATE(),
    )